package com.manlu.pojo;

import lombok.Data;

import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;

/**
 * @Auther 漫路h
 * Created by 2020-05-04 19:38
 */
@Table(name = "wx_user")
@Data
public class User {
    @Id
    private Integer wx_uid;
    private String nick_name;
    private String avatar_url;
    private String gender;
    private Date create_time;
    private String phone;
    private String country;
    private String province;
    private String city;
    private String language;
    private String openid;
    private Integer state;//状态,是否可用

    /*
     * CREATE TABLE `wx_user` (
     *   `wx_uid` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
     *   `nick_name` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '微信用户名',
     *   `avatar_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '微信用户头像',
     *   `gender` char(1) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '性别 1表示男,2表示女',
     *   `create_time` datetime DEFAULT NULL COMMENT '授权时间',
     *   `phone` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '手机号',
     *   `country` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '国',
     *   `province` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '省',
     *   `city` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '市',
     *   `language` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '语言',
     *   `openid` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '该用户唯一表示',
     *   PRIMARY KEY (`wx_uid`) USING BTREE
     * ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
     */
}
